/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package Modele;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 *
 * @author sio
 */
public class Connect {
    
    private static Connection con = null;
    private static Connection open(){
        try{
            Class.forName("org.postgresql.Driver");
        }catch(ClassNotFoundException e){
            System.out.println("Pilote mal installé");
        }
        try{
            con=DriverManager.getConnection("jdbc:postgresql://lucie/medecin","staton","linux");
        }catch(SQLException e){
            System.out.println("Erreur SQL:" +e);
        }
        return con;
    }
    
    public static Connection get(){
        if(con==null){
            con=Connect.open();
        }
        return con;
    }
    
    public static void close(){
        try{
            con.close();
        }catch(SQLException e){
            System.out.println("Erreur SQL :" + e);
        }
    }
    
    
}
